include("../header.php"); ?>
2012 Final P10 NW Select Standings
/* Database Information - Required!! */
/* -- Configure the Variables Below --*/
//include("../config.inc");
$dbhost = 'scrbowler300.ipagemysql.com';
$dbusername = 'p10select';
$dbpasswd = 'hrdbll5288?';
$database_name = 'p10xfinity';
/* Database Stuff, do not modify below this line */
$connection = mysql_pconnect("$dbhost","$dbusername","$dbpasswd")
or die ("Couldn't connect to server.");
$db = mysql_select_db("$database_name", $connection)
or die("Couldn't select database.");
?>Current Date is: Thu 11.14.2024
Pos |
Name |
Points |
Behind |
Weeks |
Min Score |
Max Score |
$query = 'SELECT * , sum( points ) , count( week ) , min( points ) , max( points ) FROM `2012seasontotals` GROUP BY name ORDER BY `sum( points )` DESC ';
$result=mysql_query($query);
$fnum=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $fnum) {
$extra=1 ;
$pos=$i+$extra ;
$p=$i-1;
$spleader=mysql_result($result,0,"sum( points )");
$rname=mysql_result($result,$i,"name");
$points=mysql_result($result,$i,"sum( points )");
$weeks=mysql_result($result,$i, "count( week )");
$min=mysql_result($result,$i, "min( points )");
$max=mysql_result($result,$i, "max( points )");
$pb=mysql_result($result,$p,"sum(points)");
$behind=$spleader-$points;
$extra=1 ;
$pos=$i+$extra ;
?>
echo "$pos"; ?> |
echo "$rname"; ?> |
echo "$points"; ?> |
echo "$behind"; ?> |
echo "$weeks"; ?> |
echo "$min"; ?> |
echo "$max"; ?> |
++$i;
}
echo "
";
?>